Re: [GENERAL] Perl DBD?

There seems to be some confusion here.

The Pg module and the DBI modules are NOT the same thing.  The first is a
postgreSQL specific perl module.  The second is an API; it has a standard
set of commands and these are applied to the database of your choice using
the appropriate driver (in this case DBD::Pg).

The fact that you mention use pg; (which by the way should be use Pg;)
implies you're trying to use the former.  But if you've already installed
DBI/DBD::Pg, why not use these instead of the Pg module?

Try

perldoc DBI
perldoc DBD::Pg

for more info on these.

If you want to use Pg get and install the Pg module from CPAN and try

perldoc Pg

or recompile postgreSQL with the --with-perl switch.

oh, and to view the tables in a database

psql <database>
\dt

HTH,

S.

>I would like to use a perl-script together with postgresql. Therefore I have
>to use the following line:
>
>use pg;
>
>I know I have to install a DBD herefore, but where can I get it? I have
>installed DBD-pg-0.92, DBI-1.06 and postgresql-6.4.2.
>A second (short) question:
>How can I view the tables in a DB?
>Thanks in advance,
>
>        Jeroen Hermans
>        Webmaster HaFaBra.nl
>        info@hafabra.nl
>
>____________________________________________
>
>De ideale LINK tussen muziek en internet:
>
>De Nationale HaFaBra-pagina, http://www.hafabra.nl
>
>Een must voor iedere muziekliefhebber!
>____________________________________________

+--------------------------+--------------------------------------+
| Stuart C. G. Rison       | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street               |
| N.B. new phone code!!    | London, W1P 8BT                      |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM                       |
| Fax. +44 (0)207 878 4040 | stuart@ludwig.ucl.ac.uk              |
+--------------------------+--------------------------------------+